package com.trkj.dao.hjj;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Timecard;

public interface TimecardDAO extends CrudRepository<Timecard, Long>{
	@Query("select t,s from Timecard t left join t.staffInformation s where t.timecardId=?1")
	public List<Object[]> findByTandS(Long timecardId);
}
